package edu.must.uh.impl;

import java.util.Map;
import edu.must.uh.bean.DeployQueryResultBean;
import edu.must.uh.util.PageHelper;
import edu.must.uh.util.SqlUtils;
import edu.must.uh.util.Tools;
import edu.must.uh.util.ToolsOfString;

public class AttendancdDaysImpl extends BaseImpl {

    public AttendancdDaysImpl() {
         super.cashkey     = "attendance_days";
         super.cashListkey = "attendance_days";
         super.keyFields   = "ID";
         super.tableName   = "attendance_days"; 
    }
    
    public  DeployQueryResultBean getLimitlist(Map<String, Object> searchcondition,
            String sqlcondition) throws Exception {        
           
            String sqlString = "SELECT  ID,CODE,ISNIGHT,HOURS,TYPE,REMARK,PERIOD FROM "+ super.tableName +" Where DeleteMark= 0  ";
            sqlString = sqlString + Tools.getSQLCondition(searchcondition);
            sqlString = sqlString +ToolsOfString.NulltoEmpty(sqlcondition) ;     
            sqlString = sqlString + PageHelper.getLimit(_PageBean);
            DeployQueryResultBean resList = SqlUtils.getMySqlInstance().getLimitlist(sqlString);
            return resList;
    }
    
}
